MacSQL Monitor provides a way to view and manipulate SQL Databases such as MySQL and Oracle. It allows you to view the schema of a database, and query,import,and export the data stored in the database.
MacSQL Monitor allows users to view schema information and issue queries to SQL Databases. Included are native drivers for MySQL, ODBC (Mac OS 8/9 only with Merant or OpenLink Software ODBC Driver Manager), and JDBC (Mac OS X only).
Features include:
• Ability to connect to MySQL, ODBC, and JDBC databases
• Complete AppleScript support including recordability and the ability to save frequently used queries as scripts for later execution
• Document History for easy access to frequently used documents
• URL Support for connecting via mysql:// URLs
• Results buffer only limited by available memory
• Multi-panel display of schema including databases, tables, columns, and indices
• Ability to export data to text files of SQL commands or tab-/comma-separated data
• Import Assistant imports SQL command files and text files
•Ability to print schema layouts and query results
• Extensive support for MacOS technologies such as AppleScript, Appearance Manager, Navigation Services, Balloon Help, Contextual Menus, Keychain, Drag & Drop, and more
MacSQL Monitor requires a PowerPC computer running MacOS 8.1 or greater with CarbonLib 1.0.4 or greater installed and access to a MySQL or ODBC-compliant database. ODBC support requires the Merant ODBC Driver Manager, available from Metro Technologies <http://www.metrotechnologies.com/>, or the Openlink Software Driver Manager, available from <http://www.openlinksw.com/>. JDBC support requires appropriate drivers to be installed in your classpath.
MacSQL Monitor is distributed as feature-limited shareware and available for download from our website <http://www.rtlabs.com/>. Unregistered copies are limited to 10 queries per connection and 2K of data per export. The software can be registered by selecting Register from the File menu, or a copy can be purchased at our website <http://www.rtlabs.com/>.
Contacting Us
For more information about MacSQL Monitor, please visit our website at <http://www.rtlabs.com/> or email info@rtlabs.com. Registered users are entitled to free email technical support by emailing support@rtlabs.com. Runtime Labs can also be reached by US Mail at:
Runtime Labs
121 W. 27th Street, Suite 201
New York, NY 10001
Version History
1.5.1 (1/17/2001)
Scripts Menu works on Mac OS X.
Added command to window menu to cycle through window tabs.
Fixed bug in getting session from document via AppleScript.
Fixed scripting bug where invalid documents were being returned.
If only 1 database exists, it is automatically selected in the query panel.
Command key equivelents are displayed for next/previous query (always worked, but did not display in menu).
Schema viewer notices create/alter/drop table queries and adjusts display.
Added support for proxy icon in window title bar.
Fixed bug with multiple MySQL documents causing a crash on menu selection.
Fixed bug that would cause crash when doing SQL Export.
Export SQL properly shows creation of primary keys from MySQL.
MySQL column definition strings now show size of column where appropriate.
Fixed bug where menus would hop around menu bar when multiple windows open.
No longer display garbage lines after an update/insert/delete query (just number of rows touched).
Added new property to session object to tell if it requires database selection.
Script Editor selection in prefs window allows selection of bundles.
Row object returns an empty string for NULL values.
Documentation folder includes AppleScript tutorials.
1.5 (1/9/2001)
Add Query to Scripts Menu works again (broken after 1.1.1).
1.5b1 (1/5/2001)
Added JDBC support (only tested with Oracle) when running on Mac OS X Public Beta.
MySQL connection speeds increased back to pre 1.1 performance (at least 2x faster).
Database plugin architecture now supports a custom menu for db-specific commands.
New import assistant imports SQL or text files.
Apple Event model changed to support creation of documents instead of sessions and windows.
MySQL Plugin offers all the functionality of mysqladmin in custom menu.
Null values no longer shift values over a column.
Exporting now works properly.
If no database is selected and tables are then listed in the schema viewer, the database whose tables are listed becomes the current database. The Query Panel database selection popup menu now correctly adjusts to show this.
1.5a1 (12/01/2000)
Carbonized to run on MacOS 8.1 or greater with CarbonLib and MacOS X.
Implemented new plugin architecture for database support.
ODBC documents can now be saved and opened (with the password stored in the keychain).
Added preference to control word wrapping in query results (defaults to no wrapping).
Date/Time header on printouts now prints on right in landscape mode.
Moved default database preference to startup panel.
Fixed bug where if auto save of documents is enabled, it is impossible to close a new connection that has never been saved (you were forced to save every document).
Holding down command key at startup causes new connection dialog be displayed.
Focus is given to the query box after selecting a database so you can immediately begin typing a query.
SQL Exports no longer place quotes around NULL.
No longer crashes if try to open a document (via recent documents) that was deleted.
Fixed crash when crop column titles is enabled and displaying data from a field with a name less than 4 characters long and the widest data for that row is less than the length of the field name.
Documents are now saved as XML plists via Core Foundation (old format can still be read).
1.1.1 (10/18/2000)
Recent documents always menu persists between application launches (the resource fork in the prefs file was not being created, only opened).
Added preference to auto save documents on close.
Oracle queries can now be made by AppleScript.
Refresh Schema works properly with mSQL databases.
History preference panel renamed to Document.
1.1 (10/16/00)
Now document-based—settings are saved to a file and connection history is now recent documents.
Added a Window menu to switch between open windows (with command key equivalents for first 10 windows).
MySQL networking code rewritten, no longer potentially corrupts hard drive.
Query field for Export dialogs now accepts queries of up to 2K in length (was limited to 256 characters).
Printing of query results no longer attempts to crop text. Instead it wraps and scaling the image in Page Setup works.
Tables listed in schema viewer can now be "Copied" (their SQL creation statement is placed on the clipboard).
Schema viewer now shows Oracle synonyms.
Oracle support now shows all schemas that have a table, view, or synonym. Previously only showed those that contained tables.
Various minor code changes to support carbonization.
1.0.1 (9/15/2000)
User name and password fields in connection dialog accept up to 64 characters instead of 16.
SQL Exports of table schema from MySQL now properly handle primary keys.
SQL Exports now use appropriate statement separator (normally semi-colon).
Removed beta-expiration that should not have been in 1.0 release.
Multiple memory leaks fixed.
1.0 (9/7/2000)
Importing now works properly with strings that contain apostrophes.
Included sample AppleScript to save data from a MySQL database to
an Microsoft Excel file.
Added preference to control if Text Encoding Converter is used to
translate data between MacRoman and Latin1 encoding.
Error message dialogs are now moveable modal dialogs.
No longer crashes when attempting to scroll through empty
command history.
When opening a database connection via Apple Events, if no password
is specified, keychain support is enabled, and the keychain is
unlocked, the password will be looked up in the keychain.
No longer crashes on initial selection of MySQL database via Apple Events.
Query window no longer inactive after displaying about box.
Queries no longer report error when the optional trailing semi-colon
is followed by a space, return, or tab.
No longer crashes when quiting on MacOS 8.1 if Internet Config is not installed.
Added Result Editing Enabled menu item to query menu (same function as pencil
icon above Make Query button).
Now distributed by Runtime Labs.
Added support for online purchase and registration.
Unregistered copies now limited to 10 queries per connection and 2K of data per export.
Complete release notes with entries for beta versions are available at <http://www.rtlabs.com/macsql/releasenotes.txt>.
Installer Notice
The installer for this product was created using Installer VISE from
MindVision Software. For more information on Installer VISE, contact:
